User's Guide

Troubleshooting the Deployment Manager Installation

If, when you initially start Deployment Manager, you receive error messages about accessing the database, you should check the log file for errors. The log file is:

nways\java\properties\log\NwaysManagerx.log

where:

• nways is the directory where you installed the product.
• x is the log number from 1 to 10. Each time the JMAintegrator server starts, a new log file is opened (NwaysManager1.log through NwaysManager10.log). After 10 log files have been opened, the file name wraps to 1 again.

When choosing the log file to edit, make sure you look at the modification dates; the most recently modified log file is the one you should open in the editor. After you open the log file, search for the line that begins STARTING CfgManService, which begins the Deployment Manager initialization. Initialization is ended with the line STARTED CfgManService.

Look for one of these errors during initialization:

• java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver

  This is caused by not having unzipped the db2java.zip file into the Nways either after installing Nways, or after installing a DB2 fixpak. To resolve this error:

  1. Locate the db2java.zip file in the DB2 product directory. On windows NT, the zip file is located in drive:\sqllib\java\. On AIX, the zip file is located in /usr/lpp/db2_05_00/java/.
  2. Unzip the db2java.zip file into the appropriate directory. On Windows NT, the directory is nways\java\websvr\code. On AIX, the directory is /usr/CML/JMA/java/websvr/code.
  3. Stop and restart the JMAintegrator process.
     1. >ovstop JMAintegrator
     2. >ovstart JMAintegrator
• COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031

  The CFGMAN database does not exist for Deployment Manager. Use the DB2 Control Center to create the database or issue this command from a DB2 command line:

  create database CFGMAN

• COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver] SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004

  The values for the Deployment Manager database user ID and/or password are incorrect. Edit the Properties file (see Database Parameters for the user ID and password parameters). Then stop and restart the JMAintegrator process:

  1. >ovstop JMAintegrator
  2. >ovstart JMAintegrator
• COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0973N Not enough storage is available in the "QUERY_HEAP" heap to process the statement. SQLSTATE=57011

  The DB2 performance parameter QUERY_HEAP_SZ for the instance needs to be increased to 10000. On Windows NT:

  1. Select the database instance, e.g. DB2.
  2. Right click and select Configure...
  3. Select the Performance tab from the Configure Instance dialog.
  4. Select Query heap size parameter and enter the new value

  On AIX:

  1. Enter the command UPDATE DATABASE MANAGER CONFIGURATION USING QUERY_HEAP_SZ 10000.

  Then:

  1. Stop the JMAintegrator process.>ovstop JMAintegrator.
  2. Stop DB2. >db2stop.
  3. Restart DB2. >db2start.
  4. Restart the JMAintegrator process.>ovstart JMAintegrator
• COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver] SQL1402N Unable to authenticate user due to unexpected system error.

  The DB2 Security Manager has not been started (for NT) or has incorrect permission bits set for db2ckpw (for AIX). On Windows NT:

  1. Open the Services applet in the NT Control Panel.
  2. Select the DB2 Security Server item in the services list.
  3. Click Start.

  On AIX, have the system administrator ensure the correct access permissions are set for db2ckpw, and that there is enough swap/paging space allocated.